<?php

class homeComponents extends sfComponents
{
  public function executeMaketree()
  {
   $this->make = MakeTable::getInstance()
           ->createQuery('make m')
           ->leftJoin('m.Vehicles v')
           ->groupBy('v.id')
           ->having('COUNT(v.id) > 0')
           ->orderBy('Name','ASC')->execute();
  }
}
